class CreateTwitterDatas < ActiveRecord::Migration
  def self.up
    create_table :twitter_datas do |t|
      t.column :crawl_id, :integer
      
      t.column :full_name, :string
      t.column :first_name, :string
      t.column :last_name, :string
      t.column :full_location, :string #locations is formatted by the user, not by the system 
      t.column :locale_language, :string# take from <lang/> tag
           
      t.column :last_update, :datetime
      #t.timestamps
    end
    add_index :twitter_datas, :crawl_id
  end

  def self.down
    remove_index :twitter_datas, :crawl_id
    drop_table :twitter_datas
  end
end
